--hive
create external table jms_dm.dm_first_code_optimize
(
 date_time          date COMMENT '揽收时间'
,first_code         string COMMENT '一段码'
,name               string COMMENT '建包名称'
,type               string COMMENT '建包类型'
,dest_center_code   string COMMENT '目的中心code'
,dest_center_name   string COMMENT '目的中心name'
,center_code        string COMMENT '末端机构编码'
,center_name        string COMMENT '末端机构名称'
,first_code_count   bigint COMMENT '一段码揽收量'
,taking_date_count  bigint COMMENT '日揽收总量'

)
comment '一段码优化'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/bidefault.db/external/dm_first_code_optimize'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');



